package com.hutao.manage.pojo;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class StdhospitalmanzyExample {
    /**
     * STDHOSPITALMANZY_
     */
    protected String orderByClause;

    /**
     * STDHOSPITALMANZY_
     */
    protected boolean distinct;

    /**
     * STDHOSPITALMANZY_
     */
    protected List<Criteria> oredCriteria;

    /**
     *
     * @代码生成于 2020-06-12
     */
    public StdhospitalmanzyExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     *
     * @代码生成于 2020-06-12
     */
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    /**
     *
     * @代码生成于 2020-06-12
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     *
     * @代码生成于 2020-06-12
     */
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    /**
     *
     * @代码生成于 2020-06-12
     */
    public boolean isDistinct() {
        return distinct;
    }

    /**
     *
     * @代码生成于 2020-06-12
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     *
     * @代码生成于 2020-06-12
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
     *
     * @代码生成于 2020-06-12
     */
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    /**
     *
     * @代码生成于 2020-06-12
     */
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /**
     *
     * @代码生成于 2020-06-12
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     *
     * @代码生成于 2020-06-12
     */
    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    /**
     * STDHOSPITALMANZY_ 2020-06-12
     */
    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("ID is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("ID is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Long value) {
            addCriterion("ID =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Long value) {
            addCriterion("ID <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Long value) {
            addCriterion("ID >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Long value) {
            addCriterion("ID >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Long value) {
            addCriterion("ID <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Long value) {
            addCriterion("ID <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Long> values) {
            addCriterion("ID in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Long> values) {
            addCriterion("ID not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Long value1, Long value2) {
            addCriterion("ID between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Long value1, Long value2) {
            addCriterion("ID not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdcardIsNull() {
            addCriterion("IDCARD_ is null");
            return (Criteria) this;
        }

        public Criteria andIdcardIsNotNull() {
            addCriterion("IDCARD_ is not null");
            return (Criteria) this;
        }

        public Criteria andIdcardEqualTo(String value) {
            addCriterion("IDCARD_ =", value, "idcard");
            return (Criteria) this;
        }

        public Criteria andIdcardNotEqualTo(String value) {
            addCriterion("IDCARD_ <>", value, "idcard");
            return (Criteria) this;
        }

        public Criteria andIdcardGreaterThan(String value) {
            addCriterion("IDCARD_ >", value, "idcard");
            return (Criteria) this;
        }

        public Criteria andIdcardGreaterThanOrEqualTo(String value) {
            addCriterion("IDCARD_ >=", value, "idcard");
            return (Criteria) this;
        }

        public Criteria andIdcardLessThan(String value) {
            addCriterion("IDCARD_ <", value, "idcard");
            return (Criteria) this;
        }

        public Criteria andIdcardLessThanOrEqualTo(String value) {
            addCriterion("IDCARD_ <=", value, "idcard");
            return (Criteria) this;
        }

        public Criteria andIdcardLike(String value) {
            addCriterion("IDCARD_ like", value, "idcard");
            return (Criteria) this;
        }

        public Criteria andIdcardNotLike(String value) {
            addCriterion("IDCARD_ not like", value, "idcard");
            return (Criteria) this;
        }

        public Criteria andIdcardIn(List<String> values) {
            addCriterion("IDCARD_ in", values, "idcard");
            return (Criteria) this;
        }

        public Criteria andIdcardNotIn(List<String> values) {
            addCriterion("IDCARD_ not in", values, "idcard");
            return (Criteria) this;
        }

        public Criteria andIdcardBetween(String value1, String value2) {
            addCriterion("IDCARD_ between", value1, value2, "idcard");
            return (Criteria) this;
        }

        public Criteria andIdcardNotBetween(String value1, String value2) {
            addCriterion("IDCARD_ not between", value1, value2, "idcard");
            return (Criteria) this;
        }

        public Criteria andNameIsNull() {
            addCriterion("NAME_ is null");
            return (Criteria) this;
        }

        public Criteria andNameIsNotNull() {
            addCriterion("NAME_ is not null");
            return (Criteria) this;
        }

        public Criteria andNameEqualTo(String value) {
            addCriterion("NAME_ =", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotEqualTo(String value) {
            addCriterion("NAME_ <>", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThan(String value) {
            addCriterion("NAME_ >", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThanOrEqualTo(String value) {
            addCriterion("NAME_ >=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThan(String value) {
            addCriterion("NAME_ <", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThanOrEqualTo(String value) {
            addCriterion("NAME_ <=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLike(String value) {
            addCriterion("NAME_ like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotLike(String value) {
            addCriterion("NAME_ not like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameIn(List<String> values) {
            addCriterion("NAME_ in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotIn(List<String> values) {
            addCriterion("NAME_ not in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameBetween(String value1, String value2) {
            addCriterion("NAME_ between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotBetween(String value1, String value2) {
            addCriterion("NAME_ not between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andParentidIsNull() {
            addCriterion("PARENTID_ is null");
            return (Criteria) this;
        }

        public Criteria andParentidIsNotNull() {
            addCriterion("PARENTID_ is not null");
            return (Criteria) this;
        }

        public Criteria andParentidEqualTo(Long value) {
            addCriterion("PARENTID_ =", value, "parentid");
            return (Criteria) this;
        }

        public Criteria andParentidNotEqualTo(Long value) {
            addCriterion("PARENTID_ <>", value, "parentid");
            return (Criteria) this;
        }

        public Criteria andParentidGreaterThan(Long value) {
            addCriterion("PARENTID_ >", value, "parentid");
            return (Criteria) this;
        }

        public Criteria andParentidGreaterThanOrEqualTo(Long value) {
            addCriterion("PARENTID_ >=", value, "parentid");
            return (Criteria) this;
        }

        public Criteria andParentidLessThan(Long value) {
            addCriterion("PARENTID_ <", value, "parentid");
            return (Criteria) this;
        }

        public Criteria andParentidLessThanOrEqualTo(Long value) {
            addCriterion("PARENTID_ <=", value, "parentid");
            return (Criteria) this;
        }

        public Criteria andParentidIn(List<Long> values) {
            addCriterion("PARENTID_ in", values, "parentid");
            return (Criteria) this;
        }

        public Criteria andParentidNotIn(List<Long> values) {
            addCriterion("PARENTID_ not in", values, "parentid");
            return (Criteria) this;
        }

        public Criteria andParentidBetween(Long value1, Long value2) {
            addCriterion("PARENTID_ between", value1, value2, "parentid");
            return (Criteria) this;
        }

        public Criteria andParentidNotBetween(Long value1, Long value2) {
            addCriterion("PARENTID_ not between", value1, value2, "parentid");
            return (Criteria) this;
        }

        public Criteria andOrgcodeIsNull() {
            addCriterion("ORGCODE_ is null");
            return (Criteria) this;
        }

        public Criteria andOrgcodeIsNotNull() {
            addCriterion("ORGCODE_ is not null");
            return (Criteria) this;
        }

        public Criteria andOrgcodeEqualTo(String value) {
            addCriterion("ORGCODE_ =", value, "orgcode");
            return (Criteria) this;
        }

        public Criteria andOrgcodeNotEqualTo(String value) {
            addCriterion("ORGCODE_ <>", value, "orgcode");
            return (Criteria) this;
        }

        public Criteria andOrgcodeGreaterThan(String value) {
            addCriterion("ORGCODE_ >", value, "orgcode");
            return (Criteria) this;
        }

        public Criteria andOrgcodeGreaterThanOrEqualTo(String value) {
            addCriterion("ORGCODE_ >=", value, "orgcode");
            return (Criteria) this;
        }

        public Criteria andOrgcodeLessThan(String value) {
            addCriterion("ORGCODE_ <", value, "orgcode");
            return (Criteria) this;
        }

        public Criteria andOrgcodeLessThanOrEqualTo(String value) {
            addCriterion("ORGCODE_ <=", value, "orgcode");
            return (Criteria) this;
        }

        public Criteria andOrgcodeLike(String value) {
            addCriterion("ORGCODE_ like", value, "orgcode");
            return (Criteria) this;
        }

        public Criteria andOrgcodeNotLike(String value) {
            addCriterion("ORGCODE_ not like", value, "orgcode");
            return (Criteria) this;
        }

        public Criteria andOrgcodeIn(List<String> values) {
            addCriterion("ORGCODE_ in", values, "orgcode");
            return (Criteria) this;
        }

        public Criteria andOrgcodeNotIn(List<String> values) {
            addCriterion("ORGCODE_ not in", values, "orgcode");
            return (Criteria) this;
        }

        public Criteria andOrgcodeBetween(String value1, String value2) {
            addCriterion("ORGCODE_ between", value1, value2, "orgcode");
            return (Criteria) this;
        }

        public Criteria andOrgcodeNotBetween(String value1, String value2) {
            addCriterion("ORGCODE_ not between", value1, value2, "orgcode");
            return (Criteria) this;
        }

        public Criteria andOrgcodeWorkIsNull() {
            addCriterion("ORGCODE_WORK_ is null");
            return (Criteria) this;
        }

        public Criteria andOrgcodeWorkIsNotNull() {
            addCriterion("ORGCODE_WORK_ is not null");
            return (Criteria) this;
        }

        public Criteria andOrgcodeWorkEqualTo(String value) {
            addCriterion("ORGCODE_WORK_ =", value, "orgcodeWork");
            return (Criteria) this;
        }

        public Criteria andOrgcodeWorkNotEqualTo(String value) {
            addCriterion("ORGCODE_WORK_ <>", value, "orgcodeWork");
            return (Criteria) this;
        }

        public Criteria andOrgcodeWorkGreaterThan(String value) {
            addCriterion("ORGCODE_WORK_ >", value, "orgcodeWork");
            return (Criteria) this;
        }

        public Criteria andOrgcodeWorkGreaterThanOrEqualTo(String value) {
            addCriterion("ORGCODE_WORK_ >=", value, "orgcodeWork");
            return (Criteria) this;
        }

        public Criteria andOrgcodeWorkLessThan(String value) {
            addCriterion("ORGCODE_WORK_ <", value, "orgcodeWork");
            return (Criteria) this;
        }

        public Criteria andOrgcodeWorkLessThanOrEqualTo(String value) {
            addCriterion("ORGCODE_WORK_ <=", value, "orgcodeWork");
            return (Criteria) this;
        }

        public Criteria andOrgcodeWorkLike(String value) {
            addCriterion("ORGCODE_WORK_ like", value, "orgcodeWork");
            return (Criteria) this;
        }

        public Criteria andOrgcodeWorkNotLike(String value) {
            addCriterion("ORGCODE_WORK_ not like", value, "orgcodeWork");
            return (Criteria) this;
        }

        public Criteria andOrgcodeWorkIn(List<String> values) {
            addCriterion("ORGCODE_WORK_ in", values, "orgcodeWork");
            return (Criteria) this;
        }

        public Criteria andOrgcodeWorkNotIn(List<String> values) {
            addCriterion("ORGCODE_WORK_ not in", values, "orgcodeWork");
            return (Criteria) this;
        }

        public Criteria andOrgcodeWorkBetween(String value1, String value2) {
            addCriterion("ORGCODE_WORK_ between", value1, value2, "orgcodeWork");
            return (Criteria) this;
        }

        public Criteria andOrgcodeWorkNotBetween(String value1, String value2) {
            addCriterion("ORGCODE_WORK_ not between", value1, value2, "orgcodeWork");
            return (Criteria) this;
        }

        public Criteria andSuborgcodeIsNull() {
            addCriterion("SUBORGCODE_ is null");
            return (Criteria) this;
        }

        public Criteria andSuborgcodeIsNotNull() {
            addCriterion("SUBORGCODE_ is not null");
            return (Criteria) this;
        }

        public Criteria andSuborgcodeEqualTo(String value) {
            addCriterion("SUBORGCODE_ =", value, "suborgcode");
            return (Criteria) this;
        }

        public Criteria andSuborgcodeNotEqualTo(String value) {
            addCriterion("SUBORGCODE_ <>", value, "suborgcode");
            return (Criteria) this;
        }

        public Criteria andSuborgcodeGreaterThan(String value) {
            addCriterion("SUBORGCODE_ >", value, "suborgcode");
            return (Criteria) this;
        }

        public Criteria andSuborgcodeGreaterThanOrEqualTo(String value) {
            addCriterion("SUBORGCODE_ >=", value, "suborgcode");
            return (Criteria) this;
        }

        public Criteria andSuborgcodeLessThan(String value) {
            addCriterion("SUBORGCODE_ <", value, "suborgcode");
            return (Criteria) this;
        }

        public Criteria andSuborgcodeLessThanOrEqualTo(String value) {
            addCriterion("SUBORGCODE_ <=", value, "suborgcode");
            return (Criteria) this;
        }

        public Criteria andSuborgcodeLike(String value) {
            addCriterion("SUBORGCODE_ like", value, "suborgcode");
            return (Criteria) this;
        }

        public Criteria andSuborgcodeNotLike(String value) {
            addCriterion("SUBORGCODE_ not like", value, "suborgcode");
            return (Criteria) this;
        }

        public Criteria andSuborgcodeIn(List<String> values) {
            addCriterion("SUBORGCODE_ in", values, "suborgcode");
            return (Criteria) this;
        }

        public Criteria andSuborgcodeNotIn(List<String> values) {
            addCriterion("SUBORGCODE_ not in", values, "suborgcode");
            return (Criteria) this;
        }

        public Criteria andSuborgcodeBetween(String value1, String value2) {
            addCriterion("SUBORGCODE_ between", value1, value2, "suborgcode");
            return (Criteria) this;
        }

        public Criteria andSuborgcodeNotBetween(String value1, String value2) {
            addCriterion("SUBORGCODE_ not between", value1, value2, "suborgcode");
            return (Criteria) this;
        }

        public Criteria andOfficecodeIsNull() {
            addCriterion("OFFICECODE_ is null");
            return (Criteria) this;
        }

        public Criteria andOfficecodeIsNotNull() {
            addCriterion("OFFICECODE_ is not null");
            return (Criteria) this;
        }

        public Criteria andOfficecodeEqualTo(String value) {
            addCriterion("OFFICECODE_ =", value, "officecode");
            return (Criteria) this;
        }

        public Criteria andOfficecodeNotEqualTo(String value) {
            addCriterion("OFFICECODE_ <>", value, "officecode");
            return (Criteria) this;
        }

        public Criteria andOfficecodeGreaterThan(String value) {
            addCriterion("OFFICECODE_ >", value, "officecode");
            return (Criteria) this;
        }

        public Criteria andOfficecodeGreaterThanOrEqualTo(String value) {
            addCriterion("OFFICECODE_ >=", value, "officecode");
            return (Criteria) this;
        }

        public Criteria andOfficecodeLessThan(String value) {
            addCriterion("OFFICECODE_ <", value, "officecode");
            return (Criteria) this;
        }

        public Criteria andOfficecodeLessThanOrEqualTo(String value) {
            addCriterion("OFFICECODE_ <=", value, "officecode");
            return (Criteria) this;
        }

        public Criteria andOfficecodeLike(String value) {
            addCriterion("OFFICECODE_ like", value, "officecode");
            return (Criteria) this;
        }

        public Criteria andOfficecodeNotLike(String value) {
            addCriterion("OFFICECODE_ not like", value, "officecode");
            return (Criteria) this;
        }

        public Criteria andOfficecodeIn(List<String> values) {
            addCriterion("OFFICECODE_ in", values, "officecode");
            return (Criteria) this;
        }

        public Criteria andOfficecodeNotIn(List<String> values) {
            addCriterion("OFFICECODE_ not in", values, "officecode");
            return (Criteria) this;
        }

        public Criteria andOfficecodeBetween(String value1, String value2) {
            addCriterion("OFFICECODE_ between", value1, value2, "officecode");
            return (Criteria) this;
        }

        public Criteria andOfficecodeNotBetween(String value1, String value2) {
            addCriterion("OFFICECODE_ not between", value1, value2, "officecode");
            return (Criteria) this;
        }

        public Criteria andCccodeIsNull() {
            addCriterion("CCCODE_ is null");
            return (Criteria) this;
        }

        public Criteria andCccodeIsNotNull() {
            addCriterion("CCCODE_ is not null");
            return (Criteria) this;
        }

        public Criteria andCccodeEqualTo(String value) {
            addCriterion("CCCODE_ =", value, "cccode");
            return (Criteria) this;
        }

        public Criteria andCccodeNotEqualTo(String value) {
            addCriterion("CCCODE_ <>", value, "cccode");
            return (Criteria) this;
        }

        public Criteria andCccodeGreaterThan(String value) {
            addCriterion("CCCODE_ >", value, "cccode");
            return (Criteria) this;
        }

        public Criteria andCccodeGreaterThanOrEqualTo(String value) {
            addCriterion("CCCODE_ >=", value, "cccode");
            return (Criteria) this;
        }

        public Criteria andCccodeLessThan(String value) {
            addCriterion("CCCODE_ <", value, "cccode");
            return (Criteria) this;
        }

        public Criteria andCccodeLessThanOrEqualTo(String value) {
            addCriterion("CCCODE_ <=", value, "cccode");
            return (Criteria) this;
        }

        public Criteria andCccodeLike(String value) {
            addCriterion("CCCODE_ like", value, "cccode");
            return (Criteria) this;
        }

        public Criteria andCccodeNotLike(String value) {
            addCriterion("CCCODE_ not like", value, "cccode");
            return (Criteria) this;
        }

        public Criteria andCccodeIn(List<String> values) {
            addCriterion("CCCODE_ in", values, "cccode");
            return (Criteria) this;
        }

        public Criteria andCccodeNotIn(List<String> values) {
            addCriterion("CCCODE_ not in", values, "cccode");
            return (Criteria) this;
        }

        public Criteria andCccodeBetween(String value1, String value2) {
            addCriterion("CCCODE_ between", value1, value2, "cccode");
            return (Criteria) this;
        }

        public Criteria andCccodeNotBetween(String value1, String value2) {
            addCriterion("CCCODE_ not between", value1, value2, "cccode");
            return (Criteria) this;
        }

        public Criteria andSubjectclassIsNull() {
            addCriterion("SUBJECTCLASS_ is null");
            return (Criteria) this;
        }

        public Criteria andSubjectclassIsNotNull() {
            addCriterion("SUBJECTCLASS_ is not null");
            return (Criteria) this;
        }

        public Criteria andSubjectclassEqualTo(String value) {
            addCriterion("SUBJECTCLASS_ =", value, "subjectclass");
            return (Criteria) this;
        }

        public Criteria andSubjectclassNotEqualTo(String value) {
            addCriterion("SUBJECTCLASS_ <>", value, "subjectclass");
            return (Criteria) this;
        }

        public Criteria andSubjectclassGreaterThan(String value) {
            addCriterion("SUBJECTCLASS_ >", value, "subjectclass");
            return (Criteria) this;
        }

        public Criteria andSubjectclassGreaterThanOrEqualTo(String value) {
            addCriterion("SUBJECTCLASS_ >=", value, "subjectclass");
            return (Criteria) this;
        }

        public Criteria andSubjectclassLessThan(String value) {
            addCriterion("SUBJECTCLASS_ <", value, "subjectclass");
            return (Criteria) this;
        }

        public Criteria andSubjectclassLessThanOrEqualTo(String value) {
            addCriterion("SUBJECTCLASS_ <=", value, "subjectclass");
            return (Criteria) this;
        }

        public Criteria andSubjectclassLike(String value) {
            addCriterion("SUBJECTCLASS_ like", value, "subjectclass");
            return (Criteria) this;
        }

        public Criteria andSubjectclassNotLike(String value) {
            addCriterion("SUBJECTCLASS_ not like", value, "subjectclass");
            return (Criteria) this;
        }

        public Criteria andSubjectclassIn(List<String> values) {
            addCriterion("SUBJECTCLASS_ in", values, "subjectclass");
            return (Criteria) this;
        }

        public Criteria andSubjectclassNotIn(List<String> values) {
            addCriterion("SUBJECTCLASS_ not in", values, "subjectclass");
            return (Criteria) this;
        }

        public Criteria andSubjectclassBetween(String value1, String value2) {
            addCriterion("SUBJECTCLASS_ between", value1, value2, "subjectclass");
            return (Criteria) this;
        }

        public Criteria andSubjectclassNotBetween(String value1, String value2) {
            addCriterion("SUBJECTCLASS_ not between", value1, value2, "subjectclass");
            return (Criteria) this;
        }

        public Criteria andIndexcodeIsNull() {
            addCriterion("INDEXCODE_ is null");
            return (Criteria) this;
        }

        public Criteria andIndexcodeIsNotNull() {
            addCriterion("INDEXCODE_ is not null");
            return (Criteria) this;
        }

        public Criteria andIndexcodeEqualTo(String value) {
            addCriterion("INDEXCODE_ =", value, "indexcode");
            return (Criteria) this;
        }

        public Criteria andIndexcodeNotEqualTo(String value) {
            addCriterion("INDEXCODE_ <>", value, "indexcode");
            return (Criteria) this;
        }

        public Criteria andIndexcodeGreaterThan(String value) {
            addCriterion("INDEXCODE_ >", value, "indexcode");
            return (Criteria) this;
        }

        public Criteria andIndexcodeGreaterThanOrEqualTo(String value) {
            addCriterion("INDEXCODE_ >=", value, "indexcode");
            return (Criteria) this;
        }

        public Criteria andIndexcodeLessThan(String value) {
            addCriterion("INDEXCODE_ <", value, "indexcode");
            return (Criteria) this;
        }

        public Criteria andIndexcodeLessThanOrEqualTo(String value) {
            addCriterion("INDEXCODE_ <=", value, "indexcode");
            return (Criteria) this;
        }

        public Criteria andIndexcodeLike(String value) {
            addCriterion("INDEXCODE_ like", value, "indexcode");
            return (Criteria) this;
        }

        public Criteria andIndexcodeNotLike(String value) {
            addCriterion("INDEXCODE_ not like", value, "indexcode");
            return (Criteria) this;
        }

        public Criteria andIndexcodeIn(List<String> values) {
            addCriterion("INDEXCODE_ in", values, "indexcode");
            return (Criteria) this;
        }

        public Criteria andIndexcodeNotIn(List<String> values) {
            addCriterion("INDEXCODE_ not in", values, "indexcode");
            return (Criteria) this;
        }

        public Criteria andIndexcodeBetween(String value1, String value2) {
            addCriterion("INDEXCODE_ between", value1, value2, "indexcode");
            return (Criteria) this;
        }

        public Criteria andIndexcodeNotBetween(String value1, String value2) {
            addCriterion("INDEXCODE_ not between", value1, value2, "indexcode");
            return (Criteria) this;
        }

        public Criteria andJobNumberIsNull() {
            addCriterion("JOB_NUMBER is null");
            return (Criteria) this;
        }

        public Criteria andJobNumberIsNotNull() {
            addCriterion("JOB_NUMBER is not null");
            return (Criteria) this;
        }

        public Criteria andJobNumberEqualTo(String value) {
            addCriterion("JOB_NUMBER =", value, "jobNumber");
            return (Criteria) this;
        }

        public Criteria andJobNumberNotEqualTo(String value) {
            addCriterion("JOB_NUMBER <>", value, "jobNumber");
            return (Criteria) this;
        }

        public Criteria andJobNumberGreaterThan(String value) {
            addCriterion("JOB_NUMBER >", value, "jobNumber");
            return (Criteria) this;
        }

        public Criteria andJobNumberGreaterThanOrEqualTo(String value) {
            addCriterion("JOB_NUMBER >=", value, "jobNumber");
            return (Criteria) this;
        }

        public Criteria andJobNumberLessThan(String value) {
            addCriterion("JOB_NUMBER <", value, "jobNumber");
            return (Criteria) this;
        }

        public Criteria andJobNumberLessThanOrEqualTo(String value) {
            addCriterion("JOB_NUMBER <=", value, "jobNumber");
            return (Criteria) this;
        }

        public Criteria andJobNumberLike(String value) {
            addCriterion("JOB_NUMBER like", value, "jobNumber");
            return (Criteria) this;
        }

        public Criteria andJobNumberNotLike(String value) {
            addCriterion("JOB_NUMBER not like", value, "jobNumber");
            return (Criteria) this;
        }

        public Criteria andJobNumberIn(List<String> values) {
            addCriterion("JOB_NUMBER in", values, "jobNumber");
            return (Criteria) this;
        }

        public Criteria andJobNumberNotIn(List<String> values) {
            addCriterion("JOB_NUMBER not in", values, "jobNumber");
            return (Criteria) this;
        }

        public Criteria andJobNumberBetween(String value1, String value2) {
            addCriterion("JOB_NUMBER between", value1, value2, "jobNumber");
            return (Criteria) this;
        }

        public Criteria andJobNumberNotBetween(String value1, String value2) {
            addCriterion("JOB_NUMBER not between", value1, value2, "jobNumber");
            return (Criteria) this;
        }

        public Criteria andCloudIdIsNull() {
            addCriterion("CLOUD_ID is null");
            return (Criteria) this;
        }

        public Criteria andCloudIdIsNotNull() {
            addCriterion("CLOUD_ID is not null");
            return (Criteria) this;
        }

        public Criteria andCloudIdEqualTo(Long value) {
            addCriterion("CLOUD_ID =", value, "cloudId");
            return (Criteria) this;
        }

        public Criteria andCloudIdNotEqualTo(Long value) {
            addCriterion("CLOUD_ID <>", value, "cloudId");
            return (Criteria) this;
        }

        public Criteria andCloudIdGreaterThan(Long value) {
            addCriterion("CLOUD_ID >", value, "cloudId");
            return (Criteria) this;
        }

        public Criteria andCloudIdGreaterThanOrEqualTo(Long value) {
            addCriterion("CLOUD_ID >=", value, "cloudId");
            return (Criteria) this;
        }

        public Criteria andCloudIdLessThan(Long value) {
            addCriterion("CLOUD_ID <", value, "cloudId");
            return (Criteria) this;
        }

        public Criteria andCloudIdLessThanOrEqualTo(Long value) {
            addCriterion("CLOUD_ID <=", value, "cloudId");
            return (Criteria) this;
        }

        public Criteria andCloudIdIn(List<Long> values) {
            addCriterion("CLOUD_ID in", values, "cloudId");
            return (Criteria) this;
        }

        public Criteria andCloudIdNotIn(List<Long> values) {
            addCriterion("CLOUD_ID not in", values, "cloudId");
            return (Criteria) this;
        }

        public Criteria andCloudIdBetween(Long value1, Long value2) {
            addCriterion("CLOUD_ID between", value1, value2, "cloudId");
            return (Criteria) this;
        }

        public Criteria andCloudIdNotBetween(Long value1, Long value2) {
            addCriterion("CLOUD_ID not between", value1, value2, "cloudId");
            return (Criteria) this;
        }

        public Criteria andCloudChangeIsNull() {
            addCriterion("CLOUD_CHANGE is null");
            return (Criteria) this;
        }

        public Criteria andCloudChangeIsNotNull() {
            addCriterion("CLOUD_CHANGE is not null");
            return (Criteria) this;
        }

        public Criteria andCloudChangeEqualTo(String value) {
            addCriterion("CLOUD_CHANGE =", value, "cloudChange");
            return (Criteria) this;
        }

        public Criteria andCloudChangeNotEqualTo(String value) {
            addCriterion("CLOUD_CHANGE <>", value, "cloudChange");
            return (Criteria) this;
        }

        public Criteria andCloudChangeGreaterThan(String value) {
            addCriterion("CLOUD_CHANGE >", value, "cloudChange");
            return (Criteria) this;
        }

        public Criteria andCloudChangeGreaterThanOrEqualTo(String value) {
            addCriterion("CLOUD_CHANGE >=", value, "cloudChange");
            return (Criteria) this;
        }

        public Criteria andCloudChangeLessThan(String value) {
            addCriterion("CLOUD_CHANGE <", value, "cloudChange");
            return (Criteria) this;
        }

        public Criteria andCloudChangeLessThanOrEqualTo(String value) {
            addCriterion("CLOUD_CHANGE <=", value, "cloudChange");
            return (Criteria) this;
        }

        public Criteria andCloudChangeLike(String value) {
            addCriterion("CLOUD_CHANGE like", value, "cloudChange");
            return (Criteria) this;
        }

        public Criteria andCloudChangeNotLike(String value) {
            addCriterion("CLOUD_CHANGE not like", value, "cloudChange");
            return (Criteria) this;
        }

        public Criteria andCloudChangeIn(List<String> values) {
            addCriterion("CLOUD_CHANGE in", values, "cloudChange");
            return (Criteria) this;
        }

        public Criteria andCloudChangeNotIn(List<String> values) {
            addCriterion("CLOUD_CHANGE not in", values, "cloudChange");
            return (Criteria) this;
        }

        public Criteria andCloudChangeBetween(String value1, String value2) {
            addCriterion("CLOUD_CHANGE between", value1, value2, "cloudChange");
            return (Criteria) this;
        }

        public Criteria andCloudChangeNotBetween(String value1, String value2) {
            addCriterion("CLOUD_CHANGE not between", value1, value2, "cloudChange");
            return (Criteria) this;
        }

        public Criteria andCloudSerialNumberIsNull() {
            addCriterion("CLOUD_SERIAL_NUMBER is null");
            return (Criteria) this;
        }

        public Criteria andCloudSerialNumberIsNotNull() {
            addCriterion("CLOUD_SERIAL_NUMBER is not null");
            return (Criteria) this;
        }

        public Criteria andCloudSerialNumberEqualTo(Long value) {
            addCriterion("CLOUD_SERIAL_NUMBER =", value, "cloudSerialNumber");
            return (Criteria) this;
        }

        public Criteria andCloudSerialNumberNotEqualTo(Long value) {
            addCriterion("CLOUD_SERIAL_NUMBER <>", value, "cloudSerialNumber");
            return (Criteria) this;
        }

        public Criteria andCloudSerialNumberGreaterThan(Long value) {
            addCriterion("CLOUD_SERIAL_NUMBER >", value, "cloudSerialNumber");
            return (Criteria) this;
        }

        public Criteria andCloudSerialNumberGreaterThanOrEqualTo(Long value) {
            addCriterion("CLOUD_SERIAL_NUMBER >=", value, "cloudSerialNumber");
            return (Criteria) this;
        }

        public Criteria andCloudSerialNumberLessThan(Long value) {
            addCriterion("CLOUD_SERIAL_NUMBER <", value, "cloudSerialNumber");
            return (Criteria) this;
        }

        public Criteria andCloudSerialNumberLessThanOrEqualTo(Long value) {
            addCriterion("CLOUD_SERIAL_NUMBER <=", value, "cloudSerialNumber");
            return (Criteria) this;
        }

        public Criteria andCloudSerialNumberIn(List<Long> values) {
            addCriterion("CLOUD_SERIAL_NUMBER in", values, "cloudSerialNumber");
            return (Criteria) this;
        }

        public Criteria andCloudSerialNumberNotIn(List<Long> values) {
            addCriterion("CLOUD_SERIAL_NUMBER not in", values, "cloudSerialNumber");
            return (Criteria) this;
        }

        public Criteria andCloudSerialNumberBetween(Long value1, Long value2) {
            addCriterion("CLOUD_SERIAL_NUMBER between", value1, value2, "cloudSerialNumber");
            return (Criteria) this;
        }

        public Criteria andCloudSerialNumberNotBetween(Long value1, Long value2) {
            addCriterion("CLOUD_SERIAL_NUMBER not between", value1, value2, "cloudSerialNumber");
            return (Criteria) this;
        }

        public Criteria andCloudChangeTimeIsNull() {
            addCriterion("CLOUD_CHANGE_TIME is null");
            return (Criteria) this;
        }

        public Criteria andCloudChangeTimeIsNotNull() {
            addCriterion("CLOUD_CHANGE_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andCloudChangeTimeEqualTo(Date value) {
            addCriterion("CLOUD_CHANGE_TIME =", value, "cloudChangeTime");
            return (Criteria) this;
        }

        public Criteria andCloudChangeTimeNotEqualTo(Date value) {
            addCriterion("CLOUD_CHANGE_TIME <>", value, "cloudChangeTime");
            return (Criteria) this;
        }

        public Criteria andCloudChangeTimeGreaterThan(Date value) {
            addCriterion("CLOUD_CHANGE_TIME >", value, "cloudChangeTime");
            return (Criteria) this;
        }

        public Criteria andCloudChangeTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("CLOUD_CHANGE_TIME >=", value, "cloudChangeTime");
            return (Criteria) this;
        }

        public Criteria andCloudChangeTimeLessThan(Date value) {
            addCriterion("CLOUD_CHANGE_TIME <", value, "cloudChangeTime");
            return (Criteria) this;
        }

        public Criteria andCloudChangeTimeLessThanOrEqualTo(Date value) {
            addCriterion("CLOUD_CHANGE_TIME <=", value, "cloudChangeTime");
            return (Criteria) this;
        }

        public Criteria andCloudChangeTimeIn(List<Date> values) {
            addCriterion("CLOUD_CHANGE_TIME in", values, "cloudChangeTime");
            return (Criteria) this;
        }

        public Criteria andCloudChangeTimeNotIn(List<Date> values) {
            addCriterion("CLOUD_CHANGE_TIME not in", values, "cloudChangeTime");
            return (Criteria) this;
        }

        public Criteria andCloudChangeTimeBetween(Date value1, Date value2) {
            addCriterion("CLOUD_CHANGE_TIME between", value1, value2, "cloudChangeTime");
            return (Criteria) this;
        }

        public Criteria andCloudChangeTimeNotBetween(Date value1, Date value2) {
            addCriterion("CLOUD_CHANGE_TIME not between", value1, value2, "cloudChangeTime");
            return (Criteria) this;
        }

        public Criteria andDirectorDepaIsNull() {
            addCriterion("DIRECTOR_DEPA is null");
            return (Criteria) this;
        }

        public Criteria andDirectorDepaIsNotNull() {
            addCriterion("DIRECTOR_DEPA is not null");
            return (Criteria) this;
        }

        public Criteria andDirectorDepaEqualTo(String value) {
            addCriterion("DIRECTOR_DEPA =", value, "directorDepa");
            return (Criteria) this;
        }

        public Criteria andDirectorDepaNotEqualTo(String value) {
            addCriterion("DIRECTOR_DEPA <>", value, "directorDepa");
            return (Criteria) this;
        }

        public Criteria andDirectorDepaGreaterThan(String value) {
            addCriterion("DIRECTOR_DEPA >", value, "directorDepa");
            return (Criteria) this;
        }

        public Criteria andDirectorDepaGreaterThanOrEqualTo(String value) {
            addCriterion("DIRECTOR_DEPA >=", value, "directorDepa");
            return (Criteria) this;
        }

        public Criteria andDirectorDepaLessThan(String value) {
            addCriterion("DIRECTOR_DEPA <", value, "directorDepa");
            return (Criteria) this;
        }

        public Criteria andDirectorDepaLessThanOrEqualTo(String value) {
            addCriterion("DIRECTOR_DEPA <=", value, "directorDepa");
            return (Criteria) this;
        }

        public Criteria andDirectorDepaLike(String value) {
            addCriterion("DIRECTOR_DEPA like", value, "directorDepa");
            return (Criteria) this;
        }

        public Criteria andDirectorDepaNotLike(String value) {
            addCriterion("DIRECTOR_DEPA not like", value, "directorDepa");
            return (Criteria) this;
        }

        public Criteria andDirectorDepaIn(List<String> values) {
            addCriterion("DIRECTOR_DEPA in", values, "directorDepa");
            return (Criteria) this;
        }

        public Criteria andDirectorDepaNotIn(List<String> values) {
            addCriterion("DIRECTOR_DEPA not in", values, "directorDepa");
            return (Criteria) this;
        }

        public Criteria andDirectorDepaBetween(String value1, String value2) {
            addCriterion("DIRECTOR_DEPA between", value1, value2, "directorDepa");
            return (Criteria) this;
        }

        public Criteria andDirectorDepaNotBetween(String value1, String value2) {
            addCriterion("DIRECTOR_DEPA not between", value1, value2, "directorDepa");
            return (Criteria) this;
        }

        public Criteria andDirectorGroupIsNull() {
            addCriterion("DIRECTOR_GROUP is null");
            return (Criteria) this;
        }

        public Criteria andDirectorGroupIsNotNull() {
            addCriterion("DIRECTOR_GROUP is not null");
            return (Criteria) this;
        }

        public Criteria andDirectorGroupEqualTo(String value) {
            addCriterion("DIRECTOR_GROUP =", value, "directorGroup");
            return (Criteria) this;
        }

        public Criteria andDirectorGroupNotEqualTo(String value) {
            addCriterion("DIRECTOR_GROUP <>", value, "directorGroup");
            return (Criteria) this;
        }

        public Criteria andDirectorGroupGreaterThan(String value) {
            addCriterion("DIRECTOR_GROUP >", value, "directorGroup");
            return (Criteria) this;
        }

        public Criteria andDirectorGroupGreaterThanOrEqualTo(String value) {
            addCriterion("DIRECTOR_GROUP >=", value, "directorGroup");
            return (Criteria) this;
        }

        public Criteria andDirectorGroupLessThan(String value) {
            addCriterion("DIRECTOR_GROUP <", value, "directorGroup");
            return (Criteria) this;
        }

        public Criteria andDirectorGroupLessThanOrEqualTo(String value) {
            addCriterion("DIRECTOR_GROUP <=", value, "directorGroup");
            return (Criteria) this;
        }

        public Criteria andDirectorGroupLike(String value) {
            addCriterion("DIRECTOR_GROUP like", value, "directorGroup");
            return (Criteria) this;
        }

        public Criteria andDirectorGroupNotLike(String value) {
            addCriterion("DIRECTOR_GROUP not like", value, "directorGroup");
            return (Criteria) this;
        }

        public Criteria andDirectorGroupIn(List<String> values) {
            addCriterion("DIRECTOR_GROUP in", values, "directorGroup");
            return (Criteria) this;
        }

        public Criteria andDirectorGroupNotIn(List<String> values) {
            addCriterion("DIRECTOR_GROUP not in", values, "directorGroup");
            return (Criteria) this;
        }

        public Criteria andDirectorGroupBetween(String value1, String value2) {
            addCriterion("DIRECTOR_GROUP between", value1, value2, "directorGroup");
            return (Criteria) this;
        }

        public Criteria andDirectorGroupNotBetween(String value1, String value2) {
            addCriterion("DIRECTOR_GROUP not between", value1, value2, "directorGroup");
            return (Criteria) this;
        }

        public Criteria andAsaIsNull() {
            addCriterion("ASA is null");
            return (Criteria) this;
        }

        public Criteria andAsaIsNotNull() {
            addCriterion("ASA is not null");
            return (Criteria) this;
        }

        public Criteria andAsaEqualTo(String value) {
            addCriterion("ASA =", value, "asa");
            return (Criteria) this;
        }

        public Criteria andAsaNotEqualTo(String value) {
            addCriterion("ASA <>", value, "asa");
            return (Criteria) this;
        }

        public Criteria andAsaGreaterThan(String value) {
            addCriterion("ASA >", value, "asa");
            return (Criteria) this;
        }

        public Criteria andAsaGreaterThanOrEqualTo(String value) {
            addCriterion("ASA >=", value, "asa");
            return (Criteria) this;
        }

        public Criteria andAsaLessThan(String value) {
            addCriterion("ASA <", value, "asa");
            return (Criteria) this;
        }

        public Criteria andAsaLessThanOrEqualTo(String value) {
            addCriterion("ASA <=", value, "asa");
            return (Criteria) this;
        }

        public Criteria andAsaLike(String value) {
            addCriterion("ASA like", value, "asa");
            return (Criteria) this;
        }

        public Criteria andAsaNotLike(String value) {
            addCriterion("ASA not like", value, "asa");
            return (Criteria) this;
        }

        public Criteria andAsaIn(List<String> values) {
            addCriterion("ASA in", values, "asa");
            return (Criteria) this;
        }

        public Criteria andAsaNotIn(List<String> values) {
            addCriterion("ASA not in", values, "asa");
            return (Criteria) this;
        }

        public Criteria andAsaBetween(String value1, String value2) {
            addCriterion("ASA between", value1, value2, "asa");
            return (Criteria) this;
        }

        public Criteria andAsaNotBetween(String value1, String value2) {
            addCriterion("ASA not between", value1, value2, "asa");
            return (Criteria) this;
        }

        public Criteria andBloodIsNull() {
            addCriterion("BLOOD is null");
            return (Criteria) this;
        }

        public Criteria andBloodIsNotNull() {
            addCriterion("BLOOD is not null");
            return (Criteria) this;
        }

        public Criteria andBloodEqualTo(Integer value) {
            addCriterion("BLOOD =", value, "blood");
            return (Criteria) this;
        }

        public Criteria andBloodNotEqualTo(Integer value) {
            addCriterion("BLOOD <>", value, "blood");
            return (Criteria) this;
        }

        public Criteria andBloodGreaterThan(Integer value) {
            addCriterion("BLOOD >", value, "blood");
            return (Criteria) this;
        }

        public Criteria andBloodGreaterThanOrEqualTo(Integer value) {
            addCriterion("BLOOD >=", value, "blood");
            return (Criteria) this;
        }

        public Criteria andBloodLessThan(Integer value) {
            addCriterion("BLOOD <", value, "blood");
            return (Criteria) this;
        }

        public Criteria andBloodLessThanOrEqualTo(Integer value) {
            addCriterion("BLOOD <=", value, "blood");
            return (Criteria) this;
        }

        public Criteria andBloodIn(List<Integer> values) {
            addCriterion("BLOOD in", values, "blood");
            return (Criteria) this;
        }

        public Criteria andBloodNotIn(List<Integer> values) {
            addCriterion("BLOOD not in", values, "blood");
            return (Criteria) this;
        }

        public Criteria andBloodBetween(Integer value1, Integer value2) {
            addCriterion("BLOOD between", value1, value2, "blood");
            return (Criteria) this;
        }

        public Criteria andBloodNotBetween(Integer value1, Integer value2) {
            addCriterion("BLOOD not between", value1, value2, "blood");
            return (Criteria) this;
        }

        public Criteria andStopedflagIsNull() {
            addCriterion("STOPEDFLAG_ is null");
            return (Criteria) this;
        }

        public Criteria andStopedflagIsNotNull() {
            addCriterion("STOPEDFLAG_ is not null");
            return (Criteria) this;
        }

        public Criteria andStopedflagEqualTo(String value) {
            addCriterion("STOPEDFLAG_ =", value, "stopedflag");
            return (Criteria) this;
        }

        public Criteria andStopedflagNotEqualTo(String value) {
            addCriterion("STOPEDFLAG_ <>", value, "stopedflag");
            return (Criteria) this;
        }

        public Criteria andStopedflagGreaterThan(String value) {
            addCriterion("STOPEDFLAG_ >", value, "stopedflag");
            return (Criteria) this;
        }

        public Criteria andStopedflagGreaterThanOrEqualTo(String value) {
            addCriterion("STOPEDFLAG_ >=", value, "stopedflag");
            return (Criteria) this;
        }

        public Criteria andStopedflagLessThan(String value) {
            addCriterion("STOPEDFLAG_ <", value, "stopedflag");
            return (Criteria) this;
        }

        public Criteria andStopedflagLessThanOrEqualTo(String value) {
            addCriterion("STOPEDFLAG_ <=", value, "stopedflag");
            return (Criteria) this;
        }

        public Criteria andStopedflagLike(String value) {
            addCriterion("STOPEDFLAG_ like", value, "stopedflag");
            return (Criteria) this;
        }

        public Criteria andStopedflagNotLike(String value) {
            addCriterion("STOPEDFLAG_ not like", value, "stopedflag");
            return (Criteria) this;
        }

        public Criteria andStopedflagIn(List<String> values) {
            addCriterion("STOPEDFLAG_ in", values, "stopedflag");
            return (Criteria) this;
        }

        public Criteria andStopedflagNotIn(List<String> values) {
            addCriterion("STOPEDFLAG_ not in", values, "stopedflag");
            return (Criteria) this;
        }

        public Criteria andStopedflagBetween(String value1, String value2) {
            addCriterion("STOPEDFLAG_ between", value1, value2, "stopedflag");
            return (Criteria) this;
        }

        public Criteria andStopedflagNotBetween(String value1, String value2) {
            addCriterion("STOPEDFLAG_ not between", value1, value2, "stopedflag");
            return (Criteria) this;
        }

        public Criteria andOnlyidIsNull() {
            addCriterion("ONLYID is null");
            return (Criteria) this;
        }

        public Criteria andOnlyidIsNotNull() {
            addCriterion("ONLYID is not null");
            return (Criteria) this;
        }

        public Criteria andOnlyidEqualTo(String value) {
            addCriterion("ONLYID =", value, "onlyid");
            return (Criteria) this;
        }

        public Criteria andOnlyidNotEqualTo(String value) {
            addCriterion("ONLYID <>", value, "onlyid");
            return (Criteria) this;
        }

        public Criteria andOnlyidGreaterThan(String value) {
            addCriterion("ONLYID >", value, "onlyid");
            return (Criteria) this;
        }

        public Criteria andOnlyidGreaterThanOrEqualTo(String value) {
            addCriterion("ONLYID >=", value, "onlyid");
            return (Criteria) this;
        }

        public Criteria andOnlyidLessThan(String value) {
            addCriterion("ONLYID <", value, "onlyid");
            return (Criteria) this;
        }

        public Criteria andOnlyidLessThanOrEqualTo(String value) {
            addCriterion("ONLYID <=", value, "onlyid");
            return (Criteria) this;
        }

        public Criteria andOnlyidLike(String value) {
            addCriterion("ONLYID like", value, "onlyid");
            return (Criteria) this;
        }

        public Criteria andOnlyidNotLike(String value) {
            addCriterion("ONLYID not like", value, "onlyid");
            return (Criteria) this;
        }

        public Criteria andOnlyidIn(List<String> values) {
            addCriterion("ONLYID in", values, "onlyid");
            return (Criteria) this;
        }

        public Criteria andOnlyidNotIn(List<String> values) {
            addCriterion("ONLYID not in", values, "onlyid");
            return (Criteria) this;
        }

        public Criteria andOnlyidBetween(String value1, String value2) {
            addCriterion("ONLYID between", value1, value2, "onlyid");
            return (Criteria) this;
        }

        public Criteria andOnlyidNotBetween(String value1, String value2) {
            addCriterion("ONLYID not between", value1, value2, "onlyid");
            return (Criteria) this;
        }

        public Criteria andObtainEvidenceIsNull() {
            addCriterion("OBTAIN_EVIDENCE is null");
            return (Criteria) this;
        }

        public Criteria andObtainEvidenceIsNotNull() {
            addCriterion("OBTAIN_EVIDENCE is not null");
            return (Criteria) this;
        }

        public Criteria andObtainEvidenceEqualTo(String value) {
            addCriterion("OBTAIN_EVIDENCE =", value, "obtainEvidence");
            return (Criteria) this;
        }

        public Criteria andObtainEvidenceNotEqualTo(String value) {
            addCriterion("OBTAIN_EVIDENCE <>", value, "obtainEvidence");
            return (Criteria) this;
        }

        public Criteria andObtainEvidenceGreaterThan(String value) {
            addCriterion("OBTAIN_EVIDENCE >", value, "obtainEvidence");
            return (Criteria) this;
        }

        public Criteria andObtainEvidenceGreaterThanOrEqualTo(String value) {
            addCriterion("OBTAIN_EVIDENCE >=", value, "obtainEvidence");
            return (Criteria) this;
        }

        public Criteria andObtainEvidenceLessThan(String value) {
            addCriterion("OBTAIN_EVIDENCE <", value, "obtainEvidence");
            return (Criteria) this;
        }

        public Criteria andObtainEvidenceLessThanOrEqualTo(String value) {
            addCriterion("OBTAIN_EVIDENCE <=", value, "obtainEvidence");
            return (Criteria) this;
        }

        public Criteria andObtainEvidenceLike(String value) {
            addCriterion("OBTAIN_EVIDENCE like", value, "obtainEvidence");
            return (Criteria) this;
        }

        public Criteria andObtainEvidenceNotLike(String value) {
            addCriterion("OBTAIN_EVIDENCE not like", value, "obtainEvidence");
            return (Criteria) this;
        }

        public Criteria andObtainEvidenceIn(List<String> values) {
            addCriterion("OBTAIN_EVIDENCE in", values, "obtainEvidence");
            return (Criteria) this;
        }

        public Criteria andObtainEvidenceNotIn(List<String> values) {
            addCriterion("OBTAIN_EVIDENCE not in", values, "obtainEvidence");
            return (Criteria) this;
        }

        public Criteria andObtainEvidenceBetween(String value1, String value2) {
            addCriterion("OBTAIN_EVIDENCE between", value1, value2, "obtainEvidence");
            return (Criteria) this;
        }

        public Criteria andObtainEvidenceNotBetween(String value1, String value2) {
            addCriterion("OBTAIN_EVIDENCE not between", value1, value2, "obtainEvidence");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeAIsNull() {
            addCriterion("SWITCH_CODE_A is null");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeAIsNotNull() {
            addCriterion("SWITCH_CODE_A is not null");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeAEqualTo(String value) {
            addCriterion("SWITCH_CODE_A =", value, "switchCodeA");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeANotEqualTo(String value) {
            addCriterion("SWITCH_CODE_A <>", value, "switchCodeA");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeAGreaterThan(String value) {
            addCriterion("SWITCH_CODE_A >", value, "switchCodeA");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeAGreaterThanOrEqualTo(String value) {
            addCriterion("SWITCH_CODE_A >=", value, "switchCodeA");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeALessThan(String value) {
            addCriterion("SWITCH_CODE_A <", value, "switchCodeA");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeALessThanOrEqualTo(String value) {
            addCriterion("SWITCH_CODE_A <=", value, "switchCodeA");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeALike(String value) {
            addCriterion("SWITCH_CODE_A like", value, "switchCodeA");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeANotLike(String value) {
            addCriterion("SWITCH_CODE_A not like", value, "switchCodeA");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeAIn(List<String> values) {
            addCriterion("SWITCH_CODE_A in", values, "switchCodeA");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeANotIn(List<String> values) {
            addCriterion("SWITCH_CODE_A not in", values, "switchCodeA");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeABetween(String value1, String value2) {
            addCriterion("SWITCH_CODE_A between", value1, value2, "switchCodeA");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeANotBetween(String value1, String value2) {
            addCriterion("SWITCH_CODE_A not between", value1, value2, "switchCodeA");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeBIsNull() {
            addCriterion("SWITCH_CODE_B is null");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeBIsNotNull() {
            addCriterion("SWITCH_CODE_B is not null");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeBEqualTo(String value) {
            addCriterion("SWITCH_CODE_B =", value, "switchCodeB");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeBNotEqualTo(String value) {
            addCriterion("SWITCH_CODE_B <>", value, "switchCodeB");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeBGreaterThan(String value) {
            addCriterion("SWITCH_CODE_B >", value, "switchCodeB");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeBGreaterThanOrEqualTo(String value) {
            addCriterion("SWITCH_CODE_B >=", value, "switchCodeB");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeBLessThan(String value) {
            addCriterion("SWITCH_CODE_B <", value, "switchCodeB");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeBLessThanOrEqualTo(String value) {
            addCriterion("SWITCH_CODE_B <=", value, "switchCodeB");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeBLike(String value) {
            addCriterion("SWITCH_CODE_B like", value, "switchCodeB");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeBNotLike(String value) {
            addCriterion("SWITCH_CODE_B not like", value, "switchCodeB");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeBIn(List<String> values) {
            addCriterion("SWITCH_CODE_B in", values, "switchCodeB");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeBNotIn(List<String> values) {
            addCriterion("SWITCH_CODE_B not in", values, "switchCodeB");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeBBetween(String value1, String value2) {
            addCriterion("SWITCH_CODE_B between", value1, value2, "switchCodeB");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeBNotBetween(String value1, String value2) {
            addCriterion("SWITCH_CODE_B not between", value1, value2, "switchCodeB");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeCIsNull() {
            addCriterion("SWITCH_CODE_C is null");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeCIsNotNull() {
            addCriterion("SWITCH_CODE_C is not null");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeCEqualTo(String value) {
            addCriterion("SWITCH_CODE_C =", value, "switchCodeC");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeCNotEqualTo(String value) {
            addCriterion("SWITCH_CODE_C <>", value, "switchCodeC");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeCGreaterThan(String value) {
            addCriterion("SWITCH_CODE_C >", value, "switchCodeC");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeCGreaterThanOrEqualTo(String value) {
            addCriterion("SWITCH_CODE_C >=", value, "switchCodeC");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeCLessThan(String value) {
            addCriterion("SWITCH_CODE_C <", value, "switchCodeC");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeCLessThanOrEqualTo(String value) {
            addCriterion("SWITCH_CODE_C <=", value, "switchCodeC");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeCLike(String value) {
            addCriterion("SWITCH_CODE_C like", value, "switchCodeC");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeCNotLike(String value) {
            addCriterion("SWITCH_CODE_C not like", value, "switchCodeC");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeCIn(List<String> values) {
            addCriterion("SWITCH_CODE_C in", values, "switchCodeC");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeCNotIn(List<String> values) {
            addCriterion("SWITCH_CODE_C not in", values, "switchCodeC");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeCBetween(String value1, String value2) {
            addCriterion("SWITCH_CODE_C between", value1, value2, "switchCodeC");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeCNotBetween(String value1, String value2) {
            addCriterion("SWITCH_CODE_C not between", value1, value2, "switchCodeC");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeDIsNull() {
            addCriterion("SWITCH_CODE_D is null");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeDIsNotNull() {
            addCriterion("SWITCH_CODE_D is not null");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeDEqualTo(String value) {
            addCriterion("SWITCH_CODE_D =", value, "switchCodeD");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeDNotEqualTo(String value) {
            addCriterion("SWITCH_CODE_D <>", value, "switchCodeD");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeDGreaterThan(String value) {
            addCriterion("SWITCH_CODE_D >", value, "switchCodeD");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeDGreaterThanOrEqualTo(String value) {
            addCriterion("SWITCH_CODE_D >=", value, "switchCodeD");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeDLessThan(String value) {
            addCriterion("SWITCH_CODE_D <", value, "switchCodeD");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeDLessThanOrEqualTo(String value) {
            addCriterion("SWITCH_CODE_D <=", value, "switchCodeD");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeDLike(String value) {
            addCriterion("SWITCH_CODE_D like", value, "switchCodeD");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeDNotLike(String value) {
            addCriterion("SWITCH_CODE_D not like", value, "switchCodeD");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeDIn(List<String> values) {
            addCriterion("SWITCH_CODE_D in", values, "switchCodeD");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeDNotIn(List<String> values) {
            addCriterion("SWITCH_CODE_D not in", values, "switchCodeD");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeDBetween(String value1, String value2) {
            addCriterion("SWITCH_CODE_D between", value1, value2, "switchCodeD");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeDNotBetween(String value1, String value2) {
            addCriterion("SWITCH_CODE_D not between", value1, value2, "switchCodeD");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeEIsNull() {
            addCriterion("SWITCH_CODE_E is null");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeEIsNotNull() {
            addCriterion("SWITCH_CODE_E is not null");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeEEqualTo(String value) {
            addCriterion("SWITCH_CODE_E =", value, "switchCodeE");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeENotEqualTo(String value) {
            addCriterion("SWITCH_CODE_E <>", value, "switchCodeE");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeEGreaterThan(String value) {
            addCriterion("SWITCH_CODE_E >", value, "switchCodeE");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeEGreaterThanOrEqualTo(String value) {
            addCriterion("SWITCH_CODE_E >=", value, "switchCodeE");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeELessThan(String value) {
            addCriterion("SWITCH_CODE_E <", value, "switchCodeE");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeELessThanOrEqualTo(String value) {
            addCriterion("SWITCH_CODE_E <=", value, "switchCodeE");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeELike(String value) {
            addCriterion("SWITCH_CODE_E like", value, "switchCodeE");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeENotLike(String value) {
            addCriterion("SWITCH_CODE_E not like", value, "switchCodeE");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeEIn(List<String> values) {
            addCriterion("SWITCH_CODE_E in", values, "switchCodeE");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeENotIn(List<String> values) {
            addCriterion("SWITCH_CODE_E not in", values, "switchCodeE");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeEBetween(String value1, String value2) {
            addCriterion("SWITCH_CODE_E between", value1, value2, "switchCodeE");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeENotBetween(String value1, String value2) {
            addCriterion("SWITCH_CODE_E not between", value1, value2, "switchCodeE");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeFIsNull() {
            addCriterion("SWITCH_CODE_F is null");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeFIsNotNull() {
            addCriterion("SWITCH_CODE_F is not null");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeFEqualTo(String value) {
            addCriterion("SWITCH_CODE_F =", value, "switchCodeF");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeFNotEqualTo(String value) {
            addCriterion("SWITCH_CODE_F <>", value, "switchCodeF");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeFGreaterThan(String value) {
            addCriterion("SWITCH_CODE_F >", value, "switchCodeF");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeFGreaterThanOrEqualTo(String value) {
            addCriterion("SWITCH_CODE_F >=", value, "switchCodeF");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeFLessThan(String value) {
            addCriterion("SWITCH_CODE_F <", value, "switchCodeF");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeFLessThanOrEqualTo(String value) {
            addCriterion("SWITCH_CODE_F <=", value, "switchCodeF");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeFLike(String value) {
            addCriterion("SWITCH_CODE_F like", value, "switchCodeF");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeFNotLike(String value) {
            addCriterion("SWITCH_CODE_F not like", value, "switchCodeF");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeFIn(List<String> values) {
            addCriterion("SWITCH_CODE_F in", values, "switchCodeF");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeFNotIn(List<String> values) {
            addCriterion("SWITCH_CODE_F not in", values, "switchCodeF");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeFBetween(String value1, String value2) {
            addCriterion("SWITCH_CODE_F between", value1, value2, "switchCodeF");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeFNotBetween(String value1, String value2) {
            addCriterion("SWITCH_CODE_F not between", value1, value2, "switchCodeF");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeGIsNull() {
            addCriterion("SWITCH_CODE_G is null");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeGIsNotNull() {
            addCriterion("SWITCH_CODE_G is not null");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeGEqualTo(String value) {
            addCriterion("SWITCH_CODE_G =", value, "switchCodeG");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeGNotEqualTo(String value) {
            addCriterion("SWITCH_CODE_G <>", value, "switchCodeG");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeGGreaterThan(String value) {
            addCriterion("SWITCH_CODE_G >", value, "switchCodeG");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeGGreaterThanOrEqualTo(String value) {
            addCriterion("SWITCH_CODE_G >=", value, "switchCodeG");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeGLessThan(String value) {
            addCriterion("SWITCH_CODE_G <", value, "switchCodeG");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeGLessThanOrEqualTo(String value) {
            addCriterion("SWITCH_CODE_G <=", value, "switchCodeG");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeGLike(String value) {
            addCriterion("SWITCH_CODE_G like", value, "switchCodeG");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeGNotLike(String value) {
            addCriterion("SWITCH_CODE_G not like", value, "switchCodeG");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeGIn(List<String> values) {
            addCriterion("SWITCH_CODE_G in", values, "switchCodeG");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeGNotIn(List<String> values) {
            addCriterion("SWITCH_CODE_G not in", values, "switchCodeG");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeGBetween(String value1, String value2) {
            addCriterion("SWITCH_CODE_G between", value1, value2, "switchCodeG");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeGNotBetween(String value1, String value2) {
            addCriterion("SWITCH_CODE_G not between", value1, value2, "switchCodeG");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeHIsNull() {
            addCriterion("SWITCH_CODE_H is null");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeHIsNotNull() {
            addCriterion("SWITCH_CODE_H is not null");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeHEqualTo(String value) {
            addCriterion("SWITCH_CODE_H =", value, "switchCodeH");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeHNotEqualTo(String value) {
            addCriterion("SWITCH_CODE_H <>", value, "switchCodeH");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeHGreaterThan(String value) {
            addCriterion("SWITCH_CODE_H >", value, "switchCodeH");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeHGreaterThanOrEqualTo(String value) {
            addCriterion("SWITCH_CODE_H >=", value, "switchCodeH");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeHLessThan(String value) {
            addCriterion("SWITCH_CODE_H <", value, "switchCodeH");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeHLessThanOrEqualTo(String value) {
            addCriterion("SWITCH_CODE_H <=", value, "switchCodeH");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeHLike(String value) {
            addCriterion("SWITCH_CODE_H like", value, "switchCodeH");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeHNotLike(String value) {
            addCriterion("SWITCH_CODE_H not like", value, "switchCodeH");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeHIn(List<String> values) {
            addCriterion("SWITCH_CODE_H in", values, "switchCodeH");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeHNotIn(List<String> values) {
            addCriterion("SWITCH_CODE_H not in", values, "switchCodeH");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeHBetween(String value1, String value2) {
            addCriterion("SWITCH_CODE_H between", value1, value2, "switchCodeH");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeHNotBetween(String value1, String value2) {
            addCriterion("SWITCH_CODE_H not between", value1, value2, "switchCodeH");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeIIsNull() {
            addCriterion("SWITCH_CODE_I is null");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeIIsNotNull() {
            addCriterion("SWITCH_CODE_I is not null");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeIEqualTo(String value) {
            addCriterion("SWITCH_CODE_I =", value, "switchCodeI");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeINotEqualTo(String value) {
            addCriterion("SWITCH_CODE_I <>", value, "switchCodeI");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeIGreaterThan(String value) {
            addCriterion("SWITCH_CODE_I >", value, "switchCodeI");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeIGreaterThanOrEqualTo(String value) {
            addCriterion("SWITCH_CODE_I >=", value, "switchCodeI");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeILessThan(String value) {
            addCriterion("SWITCH_CODE_I <", value, "switchCodeI");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeILessThanOrEqualTo(String value) {
            addCriterion("SWITCH_CODE_I <=", value, "switchCodeI");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeILike(String value) {
            addCriterion("SWITCH_CODE_I like", value, "switchCodeI");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeINotLike(String value) {
            addCriterion("SWITCH_CODE_I not like", value, "switchCodeI");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeIIn(List<String> values) {
            addCriterion("SWITCH_CODE_I in", values, "switchCodeI");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeINotIn(List<String> values) {
            addCriterion("SWITCH_CODE_I not in", values, "switchCodeI");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeIBetween(String value1, String value2) {
            addCriterion("SWITCH_CODE_I between", value1, value2, "switchCodeI");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeINotBetween(String value1, String value2) {
            addCriterion("SWITCH_CODE_I not between", value1, value2, "switchCodeI");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeJIsNull() {
            addCriterion("SWITCH_CODE_J is null");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeJIsNotNull() {
            addCriterion("SWITCH_CODE_J is not null");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeJEqualTo(String value) {
            addCriterion("SWITCH_CODE_J =", value, "switchCodeJ");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeJNotEqualTo(String value) {
            addCriterion("SWITCH_CODE_J <>", value, "switchCodeJ");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeJGreaterThan(String value) {
            addCriterion("SWITCH_CODE_J >", value, "switchCodeJ");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeJGreaterThanOrEqualTo(String value) {
            addCriterion("SWITCH_CODE_J >=", value, "switchCodeJ");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeJLessThan(String value) {
            addCriterion("SWITCH_CODE_J <", value, "switchCodeJ");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeJLessThanOrEqualTo(String value) {
            addCriterion("SWITCH_CODE_J <=", value, "switchCodeJ");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeJLike(String value) {
            addCriterion("SWITCH_CODE_J like", value, "switchCodeJ");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeJNotLike(String value) {
            addCriterion("SWITCH_CODE_J not like", value, "switchCodeJ");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeJIn(List<String> values) {
            addCriterion("SWITCH_CODE_J in", values, "switchCodeJ");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeJNotIn(List<String> values) {
            addCriterion("SWITCH_CODE_J not in", values, "switchCodeJ");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeJBetween(String value1, String value2) {
            addCriterion("SWITCH_CODE_J between", value1, value2, "switchCodeJ");
            return (Criteria) this;
        }

        public Criteria andSwitchCodeJNotBetween(String value1, String value2) {
            addCriterion("SWITCH_CODE_J not between", value1, value2, "switchCodeJ");
            return (Criteria) this;
        }
    }

    /**
     * STDHOSPITALMANZY_
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    /**
     * STDHOSPITALMANZY_ 2020-06-12
     */
    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}